Overview

Dataset statistics

Number of variables21
Number of observations10866
Missing cells13434
Missing cells (%)5.9%
Duplicate rows1
Duplicate rows (%)< 0.1%
Total size in memory1.7 MiB
Average record size in memory168.0 B

Variable types

CAT11
NUM10

Reproduction

Analysis started2020-06-18 07:22:32.645942
Analysis finished2020-06-18 07:22:46.440910
Duration13.79 seconds
Versionpandas-profiling v2.8.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Warnings

Dataset has 1 (< 0.1%) duplicate rows Duplicates
imdb_id has a high cardinality: 10855 distinct values High cardinality
original_title has a high cardinality: 10571 distinct values High cardinality
cast has a high cardinality: 10719 distinct values High cardinality
homepage has a high cardinality: 2896 distinct values High cardinality
director has a high cardinality: 5067 distinct values High cardinality
tagline has a high cardinality: 7997 distinct values High cardinality
keywords has a high cardinality: 8804 distinct values High cardinality
overview has a high cardinality: 10847 distinct values High cardinality
genres has a high cardinality: 2039 distinct values High cardinality
production_companies has a high cardinality: 7445 distinct values High cardinality
release_date has a high cardinality: 5909 distinct values High cardinality
budget_adj is highly correlated with budgetHigh correlation
budget is highly correlated with budget_adjHigh correlation
revenue_adj is highly correlated with revenueHigh correlation
revenue is highly correlated with revenue_adjHigh correlation
homepage has 7930 (73.0%) missing values Missing
tagline has 2824 (26.0%) missing values Missing
keywords has 1493 (13.7%) missing values Missing
production_companies has 1030 (9.5%) missing values Missing
imdb_id is uniformly distributed Uniform
original_title is uniformly distributed Uniform
cast is uniformly distributed Uniform
homepage is uniformly distributed Uniform
tagline is uniformly distributed Uniform
overview is uniformly distributed Uniform
budget has 5696 (52.4%) zeros Zeros
revenue has 6016 (55.4%) zeros Zeros
budget_adj has 5696 (52.4%) zeros Zeros
revenue_adj has 6016 (55.4%) zeros Zeros

Variables

id
Real number (ℝ≥0)

Distinct count10865
Unique (%)> 99.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean66064.17743419841
Minimum5
Maximum417859
Zeros0
Zeros (%)0.0%
Memory size84.9 KiB

Quantile statistics

Minimum5
5-th percentile1221
Q110596.25
median20669
Q375610
95-th percentile288556
Maximum417859
Range417854
Interquartile range (IQR)65013.75

Descriptive statistics

Standard deviation92130.13656
Coefficient of variation (CV)1.394555115
Kurtosis1.781869015
Mean66064.17743
Median Absolute Deviation (MAD)15121.5
Skewness1.732293939
Sum717853352
Variance8487962063
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
421942< 0.1%
 
20471< 0.1%
 
2512321< 0.1%
 
198191< 0.1%
 
2799141< 0.1%
 
618721< 0.1%
 
2717181< 0.1%
 
136681< 0.1%
 
1017311< 0.1%
 
13781< 0.1%
 
Other values (10855)1085599.9%
 
ValueCountFrequency (%) 
51< 0.1%
 
61< 0.1%
 
111< 0.1%
 
121< 0.1%
 
131< 0.1%
 
ValueCountFrequency (%) 
4178591< 0.1%
 
4144191< 0.1%
 
4096961< 0.1%
 
3958831< 0.1%
 
3955601< 0.1%
 

imdb_id
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count10855
Unique (%)> 99.9%
Missing10
Missing (%)0.1%
Memory size84.9 KiB
tt0411951
 
2
tt0110729
 
1
tt0342272
 
1
tt1753968
 
1
tt0095904
 
1
Other values (10850)
10850
ValueCountFrequency (%) 
tt04119512< 0.1%
 
tt01107291< 0.1%
 
tt03422721< 0.1%
 
tt17539681< 0.1%
 
tt00959041< 0.1%
 
tt01008131< 0.1%
 
tt03832221< 0.1%
 
tt00593191< 0.1%
 
tt14770761< 0.1%
 
tt34815501< 0.1%
 
Other values (10845)1084599.8%
 
(Missing)100.1%
 

Length

Max length9
Median length9
Mean length8.994478189
Min length3

popularity
Real number (ℝ≥0)

Distinct count10814
Unique (%)99.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.6464409519602429
Minimum6.500000000000001e-05
Maximum32.985763
Zeros0
Zeros (%)0.0%
Memory size84.9 KiB

Quantile statistics

Minimum6.5e-05
5-th percentile0.06425225
Q10.20758275
median0.3838555
Q30.713817
95-th percentile2.04660175
Maximum32.985763
Range32.985698
Interquartile range (IQR)0.50623425

Descriptive statistics

Standard deviation1.000184934
Coefficient of variation (CV)1.54721778
Kurtosis210.9981321
Mean0.646440952
Median Absolute Deviation (MAD)0.2153785
Skewness9.876331256
Sum7024.227384
Variance1.000369903
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.1093052< 0.1%
 
0.1140272< 0.1%
 
0.1261822< 0.1%
 
0.2479262< 0.1%
 
0.4102352< 0.1%
 
0.1225432< 0.1%
 
0.3586942< 0.1%
 
0.1555192< 0.1%
 
0.9842562< 0.1%
 
0.4685522< 0.1%
 
Other values (10804)1084699.8%
 
ValueCountFrequency (%) 
6.5e-051< 0.1%
 
0.0001881< 0.1%
 
0.000621< 0.1%
 
0.0009731< 0.1%
 
0.0011151< 0.1%
 
ValueCountFrequency (%) 
32.9857631< 0.1%
 
28.4199361< 0.1%
 
24.9491341< 0.1%
 
14.3112051< 0.1%
 
13.1125071< 0.1%
 

budget
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct count557
Unique (%)5.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14625701.09414688
Minimum0
Maximum425000000
Zeros5696
Zeros (%)52.4%
Memory size84.9 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q315000000
95-th percentile75000000
Maximum425000000
Range425000000
Interquartile range (IQR)15000000

Descriptive statistics

Standard deviation30913213.83
Coefficient of variation (CV)2.1136227
Kurtosis19.26943617
Mean14625701.09
Median Absolute Deviation (MAD)0
Skewness3.717237057
Sum1.589228681e+11
Variance9.556267894e+14
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0569652.4%
 
200000001901.7%
 
150000001831.7%
 
250000001781.6%
 
100000001761.6%
 
300000001651.5%
 
50000001411.3%
 
400000001341.2%
 
350000001281.2%
 
120000001201.1%
 
Other values (547)375534.6%
 
ValueCountFrequency (%) 
0569652.4%
 
14< 0.1%
 
21< 0.1%
 
33< 0.1%
 
51< 0.1%
 
ValueCountFrequency (%) 
4250000001< 0.1%
 
3800000001< 0.1%
 
3000000001< 0.1%
 
2800000001< 0.1%
 
2700000001< 0.1%
 

revenue
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct count4702
Unique (%)43.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean39823319.79339223
Minimum0
Maximum2781505847
Zeros6016
Zeros (%)55.4%
Memory size84.9 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q324000000
95-th percentile213672164.5
Maximum2781505847
Range2781505847
Interquartile range (IQR)24000000

Descriptive statistics

Standard deviation117003486.6
Coefficient of variation (CV)2.938064611
Kurtosis73.16848928
Mean39823319.79
Median Absolute Deviation (MAD)0
Skewness6.658397231
Sum4.327201929e+11
Variance1.368981587e+16
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0601655.4%
 
12000000100.1%
 
1000000080.1%
 
1100000070.1%
 
600000060.1%
 
500000060.1%
 
200000060.1%
 
130000005< 0.1%
 
200000005< 0.1%
 
140000005< 0.1%
 
Other values (4692)479244.1%
 
ValueCountFrequency (%) 
0601655.4%
 
22< 0.1%
 
33< 0.1%
 
52< 0.1%
 
62< 0.1%
 
ValueCountFrequency (%) 
27815058471< 0.1%
 
20681782251< 0.1%
 
18450341881< 0.1%
 
15195579101< 0.1%
 
15135288101< 0.1%
 

original_title
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count10571
Unique (%)97.3%
Missing0
Missing (%)0.0%
Memory size84.9 KiB
Hamlet
 
4
Alice in Wonderland
 
3
Shelter
 
3
Beauty and the Beast
 
3
Hercules
 
3
Other values (10566)
10850
ValueCountFrequency (%) 
Hamlet4< 0.1%
 
Alice in Wonderland3< 0.1%
 
Shelter3< 0.1%
 
Beauty and the Beast3< 0.1%
 
Hercules3< 0.1%
 
The Black Hole3< 0.1%
 
Life3< 0.1%
 
Emma3< 0.1%
 
Julia3< 0.1%
 
Frankenstein3< 0.1%
 
Other values (10561)1083599.7%
 

Length

Max length104
Median length14
Mean length16.00220872
Min length1

cast
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count10719
Unique (%)99.3%
Missing76
Missing (%)0.7%
Memory size84.9 KiB
Louis C.K.
 
6
William Shatner|Leonard Nimoy|DeForest Kelley|James Doohan|George Takei
 
5
Bill Burr
 
4
Jennifer Lawrence|Josh Hutcherson|Liam Hemsworth|Woody Harrelson|Elizabeth Banks
 
3
Pierre Coffin
 
3
Other values (10714)
10769
ValueCountFrequency (%) 
Louis C.K.60.1%
 
William Shatner|Leonard Nimoy|DeForest Kelley|James Doohan|George Takei5< 0.1%
 
Bill Burr4< 0.1%
 
Jennifer Lawrence|Josh Hutcherson|Liam Hemsworth|Woody Harrelson|Elizabeth Banks3< 0.1%
 
Pierre Coffin3< 0.1%
 
Chris Wedge3< 0.1%
 
Elijah Wood|Ian McKellen|Viggo Mortensen|Liv Tyler|Orlando Bloom3< 0.1%
 
Sylvester Stallone|Talia Shire|Burt Young|Carl Weathers|Burgess Meredith3< 0.1%
 
Aziz Ansari3< 0.1%
 
Zac Efron|Vanessa Hudgens|Ashley Tisdale|Lucas Grabeel|Corbin Bleu3< 0.1%
 
Other values (10709)1075499.0%
 
(Missing)760.7%
 

Length

Max length110
Median length69
Mean length67.41882938
Min length3

homepage
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct count2896
Unique (%)98.6%
Missing7930
Missing (%)73.0%
Memory size84.9 KiB
http://www.thehungergames.movie/
 
4
http://www.missionimpossible.com/
 
4
http://phantasm.com
 
4
http://www.thehobbit.com/
 
3
http://www.americanreunionmovie.com/
 
3
Other values (2891)
2918
ValueCountFrequency (%) 
http://www.thehungergames.movie/4< 0.1%
 
http://www.missionimpossible.com/4< 0.1%
 
http://phantasm.com4< 0.1%
 
http://www.thehobbit.com/3< 0.1%
 
http://www.americanreunionmovie.com/3< 0.1%
 
http://www.jeffdunham.com3< 0.1%
 
http://www.transformersmovie.com/3< 0.1%
 
http://www.georgecarlin.com3< 0.1%
 
http://www.kungfupanda.com/3< 0.1%
 
http://www.beowulfmovie.com/2< 0.1%
 
Other values (2886)290426.7%
 
(Missing)793073.0%
 

Length

Max length242
Median length3
Mean length12.22630223
Min length3

director
Categorical

HIGH CARDINALITY

Distinct count5067
Unique (%)46.8%
Missing44
Missing (%)0.4%
Memory size84.9 KiB
Woody Allen
 
45
Clint Eastwood
 
34
Steven Spielberg
 
29
Martin Scorsese
 
29
Ridley Scott
 
23
Other values (5062)
10662
ValueCountFrequency (%) 
Woody Allen450.4%
 
Clint Eastwood340.3%
 
Steven Spielberg290.3%
 
Martin Scorsese290.3%
 
Ridley Scott230.2%
 
Ron Howard220.2%
 
Steven Soderbergh220.2%
 
Joel Schumacher210.2%
 
Brian De Palma200.2%
 
Tim Burton190.2%
 
Other values (5057)1055897.2%
 
(Missing)440.4%
 

Length

Max length533
Median length13
Mean length14.51131971
Min length2

tagline
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct count7997
Unique (%)99.4%
Missing2824
Missing (%)26.0%
Memory size84.9 KiB
Based on a true story.
 
5
Be careful what you wish for.
 
3
Two Films. One Love.
 
3
You never forget your first love.
 
2
A Love Story
 
2
Other values (7992)
8027
ValueCountFrequency (%) 
Based on a true story.5< 0.1%
 
Be careful what you wish for.3< 0.1%
 
Two Films. One Love.3< 0.1%
 
You never forget your first love.2< 0.1%
 
A Love Story2< 0.1%
 
Forget About Love2< 0.1%
 
-2< 0.1%
 
The chase is on!2< 0.1%
 
Worlds Collide2< 0.1%
 
One ordinary couple. One little white lie.2< 0.1%
 
Other values (7987)801773.8%
 
(Missing)282426.0%
 

Length

Max length286
Median length30
Mean length33.47349531
Min length1

keywords
Categorical

HIGH CARDINALITY
MISSING

Distinct count8804
Unique (%)93.9%
Missing1493
Missing (%)13.7%
Memory size84.9 KiB
woman director
 
134
independent film
 
82
sport
 
25
musical
 
24
duringcreditsstinger
 
24
Other values (8799)
9084
ValueCountFrequency (%) 
woman director1341.2%
 
independent film820.8%
 
sport250.2%
 
musical240.2%
 
duringcreditsstinger240.2%
 
suspense240.2%
 
holiday160.1%
 
stand-up|stand up comedy160.1%
 
biography150.1%
 
independent film|woman director130.1%
 
Other values (8794)900082.8%
 
(Missing)149313.7%
 

Length

Max length131
Median length40
Mean length36.61761458
Min length2

overview
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count10847
Unique (%)99.9%
Missing4
Missing (%)< 0.1%
Memory size84.9 KiB
No overview found.
 
13
Wilbur the pig is scared of the end of the season, because he knows that come that time, he will end up on the dinner table. He hatches a plan with Charlotte, a spider that lives in his pen, to ensure that this will never happen.
 
2
1960. The thrilling battles waged by a band of kids from two rival villages in the southern French countryside.
 
2
In the year of 2039, after World Wars destroy much of the civilization as we know it, territories are no longer run by governments, but by corporations; the mightiest of which is the Mishima Zaibatsu. In order to placate the seething masses of this dystopia, Mishima sponsors Tekken, a tournament in which fighters battle until only one is left standing.
 
2
As the English and French soldiers battle for control of the North American colonies in the 18th century, the settlers and native Americans are forced to take sides. Cora and her sister Alice unwittingly walk into trouble but are saved by Hawkeye, an orphaned settler adopted by the last of the Mohicans.
 
1
Other values (10842)
10842
ValueCountFrequency (%) 
No overview found.130.1%
 
Wilbur the pig is scared of the end of the season, because he knows that come that time, he will end up on the dinner table. He hatches a plan with Charlotte, a spider that lives in his pen, to ensure that this will never happen.2< 0.1%
 
1960. The thrilling battles waged by a band of kids from two rival villages in the southern French countryside.2< 0.1%
 
In the year of 2039, after World Wars destroy much of the civilization as we know it, territories are no longer run by governments, but by corporations; the mightiest of which is the Mishima Zaibatsu. In order to placate the seething masses of this dystopia, Mishima sponsors Tekken, a tournament in which fighters battle until only one is left standing.2< 0.1%
 
As the English and French soldiers battle for control of the North American colonies in the 18th century, the settlers and native Americans are forced to take sides. Cora and her sister Alice unwittingly walk into trouble but are saved by Hawkeye, an orphaned settler adopted by the last of the Mohicans.1< 0.1%
 
In a quiet suburban town in the summer of 1958, two recently orphaned sisters are placed in the care of their mentally unstable Aunt Ruth. But Ruth's depraved sense of discipline will soon lead to unspeakable acts of abuse and torture that involve her young sons, the neighborhood children, and one 12-year-old boy whose life will be changed forever.1< 0.1%
 
The story throws Elvis impersonators, Indians, modern cowboys, a 6-foot-tall blond assassin, a frat boy, a corrupt sheriff and a prostitute into a chase for a priceless American Indian artifact stolen during a poker game at an Indian casino1< 0.1%
 
Hick handymen Val McKee and Earl Bassett can barely eke out a living in the Nevada hamlet of Perfection, so they decide to leave town -- despite an admonition from a shapely seismology coed who's picking up odd readings on her equipment. Before long, Val and Earl discover what's responsible for those readings: 30-foot-long carnivorous worms with a proclivity for sucking their prey underground.1< 0.1%
 
A U.S. satellite crash-lands near a small town in Utah, unleashing a deadly plague that kills virtually everyone except two survivors, who may provide clues to immunizing the population. As the military attempts to quarantine the area, a team of highly specialized scientists is assembled to find a cure and stop the spread of the alien pathogen, code-named Andromeda.1< 0.1%
 
Willy the whale is back, this time threatened by illegal whalers making money off sushi. Jesse, now 16, has taken a job on an orca-researching ship, along with old friend Randolph and a sarcastic scientist, Drew. On the whaler's ship is captain John Wesley and his son, Max, who isn't really pleased about his father's job, but doesn't have the gut to say so. Along the way, Willy reunites with Jesse1< 0.1%
 
Other values (10837)1083799.7%
 
(Missing)4< 0.1%
 

Length

Max length1000
Median length282
Mean length306.9256396
Min length3

runtime
Real number (ℝ≥0)

Distinct count247
Unique (%)2.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean102.07086324314375
Minimum0
Maximum900
Zeros31
Zeros (%)0.3%
Memory size84.9 KiB

Quantile statistics

Minimum0
5-th percentile75
Q190
median99
Q3111
95-th percentile139
Maximum900
Range900
Interquartile range (IQR)21

Descriptive statistics

Standard deviation31.38140508
Coefficient of variation (CV)0.307447239
Kurtosis116.2375673
Mean102.0708632
Median Absolute Deviation (MAD)10
Skewness6.103792811
Sum1109102
Variance984.7925849
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
905475.0%
 
953583.3%
 
1003353.1%
 
933283.0%
 
973062.8%
 
963002.8%
 
912972.7%
 
942922.7%
 
922702.5%
 
982702.5%
 
Other values (237)756369.6%
 
ValueCountFrequency (%) 
0310.3%
 
25< 0.1%
 
3110.1%
 
4170.2%
 
5170.2%
 
ValueCountFrequency (%) 
9001< 0.1%
 
8771< 0.1%
 
7051< 0.1%
 
5661< 0.1%
 
5611< 0.1%
 

genres
Categorical

HIGH CARDINALITY

Distinct count2039
Unique (%)18.8%
Missing23
Missing (%)0.2%
Memory size84.9 KiB
Comedy
 
712
Drama
 
712
Documentary
 
312
Drama|Romance
 
289
Comedy|Drama
 
280
Other values (2034)
8538
ValueCountFrequency (%) 
Comedy7126.6%
 
Drama7126.6%
 
Documentary3122.9%
 
Drama|Romance2892.7%
 
Comedy|Drama2802.6%
 
Comedy|Romance2682.5%
 
Horror|Thriller2592.4%
 
Horror2532.3%
 
Comedy|Drama|Romance2222.0%
 
Drama|Thriller1381.3%
 
Other values (2029)739868.1%
 

Length

Max length51
Median length17
Mean length18.50423339
Min length3

production_companies
Categorical

HIGH CARDINALITY
MISSING

Distinct count7445
Unique (%)75.7%
Missing1030
Missing (%)9.5%
Memory size84.9 KiB
Paramount Pictures
 
156
Universal Pictures
 
133
Warner Bros.
 
84
Walt Disney Pictures
 
76
Columbia Pictures
 
72
Other values (7440)
9315
ValueCountFrequency (%) 
Paramount Pictures1561.4%
 
Universal Pictures1331.2%
 
Warner Bros.840.8%
 
Walt Disney Pictures760.7%
 
Columbia Pictures720.7%
 
Metro-Goldwyn-Mayer (MGM)720.7%
 
New Line Cinema610.6%
 
Touchstone Pictures510.5%
 
20th Century Fox500.5%
 
Twentieth Century Fox Film Corporation490.5%
 
Other values (7435)903283.1%
 
(Missing)10309.5%
 

Length

Max length184
Median length36
Mean length41.48601141
Min length3

release_date
Categorical

HIGH CARDINALITY

Distinct count5909
Unique (%)54.4%
Missing0
Missing (%)0.0%
Memory size84.9 KiB
1/1/09
 
28
1/1/08
 
21
1/1/07
 
18
1/1/05
 
16
10/10/14
 
15
Other values (5904)
10768
ValueCountFrequency (%) 
1/1/09280.3%
 
1/1/08210.2%
 
1/1/07180.2%
 
1/1/05160.1%
 
10/10/14150.1%
 
1/1/06130.1%
 
1/1/03130.1%
 
9/7/12130.1%
 
1/1/12120.1%
 
10/16/15120.1%
 
Other values (5899)1070598.5%
 

Length

Max length8
Median length7
Mean length6.960058899
Min length6

vote_count
Real number (ℝ≥0)

Distinct count1289
Unique (%)11.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean217.38974783729063
Minimum10
Maximum9767
Zeros0
Zeros (%)0.0%
Memory size84.9 KiB

Quantile statistics

Minimum10
5-th percentile11
Q117
median38
Q3145.75
95-th percentile1025.75
Maximum9767
Range9757
Interquartile range (IQR)128.75

Descriptive statistics

Standard deviation575.6190577
Coefficient of variation (CV)2.647866624
Kurtosis53.36097878
Mean217.3897478
Median Absolute Deviation (MAD)26
Skewness6.177305758
Sum2362157
Variance331337.2996
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
105014.6%
 
114744.4%
 
124223.9%
 
133773.5%
 
143233.0%
 
153002.8%
 
162702.5%
 
172562.4%
 
182182.0%
 
191891.7%
 
Other values (1279)753669.4%
 
ValueCountFrequency (%) 
105014.6%
 
114744.4%
 
124223.9%
 
133773.5%
 
143233.0%
 
ValueCountFrequency (%) 
97671< 0.1%
 
89031< 0.1%
 
84581< 0.1%
 
84321< 0.1%
 
73751< 0.1%
 

vote_average
Real number (ℝ≥0)

Distinct count72
Unique (%)0.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.9749217743419845
Minimum1.5
Maximum9.2
Zeros0
Zeros (%)0.0%
Memory size84.9 KiB

Quantile statistics

Minimum1.5
5-th percentile4.4
Q15.4
median6
Q36.6
95-th percentile7.4
Maximum9.2
Range7.7
Interquartile range (IQR)1.2

Descriptive statistics

Standard deviation0.9351418153
Coefficient of variation (CV)0.1565111395
Kurtosis0.5435032543
Mean5.974921774
Median Absolute Deviation (MAD)0.6
Skewness-0.4359079754
Sum64923.5
Variance0.8744902148
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
6.14964.6%
 
64954.6%
 
5.84864.5%
 
5.94734.4%
 
6.24644.3%
 
6.34614.2%
 
6.54574.2%
 
6.44464.1%
 
5.74153.8%
 
6.64133.8%
 
Other values (62)626057.6%
 
ValueCountFrequency (%) 
1.52< 0.1%
 
21< 0.1%
 
2.13< 0.1%
 
2.23< 0.1%
 
2.32< 0.1%
 
ValueCountFrequency (%) 
9.21< 0.1%
 
8.91< 0.1%
 
8.82< 0.1%
 
8.71< 0.1%
 
8.61< 0.1%
 

release_year
Real number (ℝ≥0)

Distinct count56
Unique (%)0.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2001.3226578317688
Minimum1960
Maximum2015
Zeros0
Zeros (%)0.0%
Memory size84.9 KiB

Quantile statistics

Minimum1960
5-th percentile1973
Q11995
median2006
Q32011
95-th percentile2015
Maximum2015
Range55
Interquartile range (IQR)16

Descriptive statistics

Standard deviation12.81294057
Coefficient of variation (CV)0.006402236302
Kurtosis0.8000513183
Mean2001.322658
Median Absolute Deviation (MAD)7
Skewness-1.204254294
Sum21746372
Variance164.1714461
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
20147006.4%
 
20136596.1%
 
20156295.8%
 
20125885.4%
 
20115405.0%
 
20095334.9%
 
20084964.6%
 
20104904.5%
 
20074384.0%
 
20064083.8%
 
Other values (46)538549.6%
 
ValueCountFrequency (%) 
1960320.3%
 
1961310.3%
 
1962320.3%
 
1963340.3%
 
1964420.4%
 
ValueCountFrequency (%) 
20156295.8%
 
20147006.4%
 
20136596.1%
 
20125885.4%
 
20115405.0%
 

budget_adj
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct count2614
Unique (%)24.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean17551039.82288678
Minimum0.0
Maximum425000000.0
Zeros5696
Zeros (%)52.4%
Memory size84.9 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q320853251.08
95-th percentile89375137.94
Maximum425000000
Range425000000
Interquartile range (IQR)20853251.08

Descriptive statistics

Standard deviation34306155.72
Coefficient of variation (CV)1.954650896
Kurtosis13.03695179
Mean17551039.82
Median Absolute Deviation (MAD)0
Skewness3.114919907
Sum1.907095987e+11
Variance1.17691232e+15
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0569652.4%
 
10164004.34170.2%
 
21033371.65170.2%
 
20000000160.1%
 
4605455.254150.1%
 
33496898.69140.1%
 
24234951.06140.1%
 
20328008.68130.1%
 
40656017.36130.1%
 
26291714.57130.1%
 
Other values (2604)503846.4%
 
ValueCountFrequency (%) 
0569652.4%
 
0.92109105081< 0.1%
 
0.96939804261< 0.1%
 
1.0127866341< 0.1%
 
1.3090528471< 0.1%
 
ValueCountFrequency (%) 
4250000001< 0.1%
 
368371256.21< 0.1%
 
315500574.81< 0.1%
 
292050672.71< 0.1%
 
271692064.21< 0.1%
 

revenue_adj
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct count4840
Unique (%)44.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean51364363.25325099
Minimum0.0
Maximum2827123750.41189
Zeros6016
Zeros (%)55.4%
Memory size84.9 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q333697095.72
95-th percentile276554439
Maximum2827123750
Range2827123750
Interquartile range (IQR)33697095.72

Descriptive statistics

Standard deviation144632485
Coefficient of variation (CV)2.815813842
Kurtosis63.37990799
Mean51364363.25
Median Absolute Deviation (MAD)0
Skewness6.251202093
Sum5.581251711e+11
Variance2.091855573e+16
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0601655.4%
 
14389144.832< 0.1%
 
57667591.032< 0.1%
 
10000002< 0.1%
 
209354710.52< 0.1%
 
29106404.282< 0.1%
 
81036423.442< 0.1%
 
9670002< 0.1%
 
89906740.122< 0.1%
 
317214592< 0.1%
 
Other values (4830)483244.5%
 
ValueCountFrequency (%) 
0601655.4%
 
2.370705291< 0.1%
 
2.8619337341< 0.1%
 
3.0383599011< 0.1%
 
5.9267632241< 0.1%
 
ValueCountFrequency (%) 
28271237501< 0.1%
 
27897122421< 0.1%
 
25064057351< 0.1%
 
21673249011< 0.1%
 
19070058421< 0.1%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Missing values

Sample

First rows

idimdb_idpopularitybudgetrevenueoriginal_titlecasthomepagedirectortaglinekeywordsoverviewruntimegenresproduction_companiesrelease_datevote_countvote_averagerelease_yearbudget_adjrevenue_adj
0135397tt036961032.9857631500000001513528810Jurassic WorldChris Pratt|Bryce Dallas Howard|Irrfan Khan|Vincent D'Onofrio|Nick Robinsonhttp://www.jurassicworld.com/Colin TrevorrowThe park is open.monster|dna|tyrannosaurus rex|velociraptor|islandTwenty-two years after the events of Jurassic Park, Isla Nublar now features a fully functioning dinosaur theme park, Jurassic World, as originally envisioned by John Hammond.124Action|Adventure|Science Fiction|ThrillerUniversal Studios|Amblin Entertainment|Legendary Pictures|Fuji Television Network|Dentsu6/9/1555626.520151.379999e+081.392446e+09
176341tt139219028.419936150000000378436354Mad Max: Fury RoadTom Hardy|Charlize Theron|Hugh Keays-Byrne|Nicholas Hoult|Josh Helmanhttp://www.madmaxmovie.com/George MillerWhat a Lovely Day.future|chase|post-apocalyptic|dystopia|australiaAn apocalyptic story set in the furthest reaches of our planet, in a stark desert landscape where humanity is broken, and most everyone is crazed fighting for the necessities of life. Within this world exist two rebels on the run who just might be able to restore order. There's Max, a man of action and a man of few words, who seeks peace of mind following the loss of his wife and child in the aftermath of the chaos. And Furiosa, a woman of action and a woman who believes her path to survival may be achieved if she can make it across the desert back to her childhood homeland.120Action|Adventure|Science Fiction|ThrillerVillage Roadshow Pictures|Kennedy Miller Productions5/13/1561857.120151.379999e+083.481613e+08
2262500tt290844613.112507110000000295238201InsurgentShailene Woodley|Theo James|Kate Winslet|Ansel Elgort|Miles Tellerhttp://www.thedivergentseries.movie/#insurgentRobert SchwentkeOne Choice Can Destroy Youbased on novel|revolution|dystopia|sequel|dystopic futureBeatrice Prior must confront her inner demons and continue her fight against a powerful alliance which threatens to tear her society apart.119Adventure|Science Fiction|ThrillerSummit Entertainment|Mandeville Films|Red Wagon Entertainment|NeoReel3/18/1524806.320151.012000e+082.716190e+08
3140607tt248849611.1731042000000002068178225Star Wars: The Force AwakensHarrison Ford|Mark Hamill|Carrie Fisher|Adam Driver|Daisy Ridleyhttp://www.starwars.com/films/star-wars-episode-viiJ.J. AbramsEvery generation has a story.android|spaceship|jedi|space opera|3dThirty years after defeating the Galactic Empire, Han Solo and his allies face a new threat from the evil Kylo Ren and his army of Stormtroopers.136Action|Adventure|Science Fiction|FantasyLucasfilm|Truenorth Productions|Bad Robot12/15/1552927.520151.839999e+081.902723e+09
4168259tt28208529.3350141900000001506249360Furious 7Vin Diesel|Paul Walker|Jason Statham|Michelle Rodriguez|Dwayne Johnsonhttp://www.furious7.com/James WanVengeance Hits Homecar race|speed|revenge|suspense|carDeckard Shaw seeks revenge against Dominic Toretto and his family for his comatose brother.137Action|Crime|ThrillerUniversal Pictures|Original Film|Media Rights Capital|Dentsu|One Race Films4/1/1529477.320151.747999e+081.385749e+09
5281957tt16632029.110700135000000532950503The RevenantLeonardo DiCaprio|Tom Hardy|Will Poulter|Domhnall Gleeson|Paul Andersonhttp://www.foxmovies.com/movies/the-revenantAlejandro González Iñárritu(n. One who has returned, as if from the dead.)father-son relationship|rape|based on novel|mountains|winterIn the 1820s, a frontiersman, Hugh Glass, sets out on a path of vengeance against those who left him for dead after a bear mauling.156Western|Drama|Adventure|ThrillerRegency Enterprises|Appian Way|CatchPlay|Anonymous Content|New Regency Pictures12/25/1539297.220151.241999e+084.903142e+08
687101tt13401388.654359155000000440603537Terminator GenisysArnold Schwarzenegger|Jason Clarke|Emilia Clarke|Jai Courtney|J.K. Simmonshttp://www.terminatormovie.com/Alan TaylorReset the futuresaving the world|artificial intelligence|cyborg|killer robot|futureThe year is 2029. John Connor, leader of the resistance continues the war against the machines. At the Los Angeles offensive, John's fears of the unknown future begin to emerge when TECOM spies reveal a new plot by SkyNet that will attack him from both fronts; past and future, and will ultimately change warfare forever.125Science Fiction|Action|Thriller|AdventureParamount Pictures|Skydance Productions6/23/1525985.820151.425999e+084.053551e+08
7286217tt36593887.667400108000000595380321The MartianMatt Damon|Jessica Chastain|Kristen Wiig|Jeff Daniels|Michael Peñahttp://www.foxmovies.com/movies/the-martianRidley ScottBring Him Homebased on novel|mars|nasa|isolation|botanistDuring a manned mission to Mars, Astronaut Mark Watney is presumed dead after a fierce storm and left behind by his crew. But Watney has survived and finds himself stranded and alone on the hostile planet. With only meager supplies, he must draw upon his ingenuity, wit and spirit to subsist and find a way to signal to Earth that he is alive.141Drama|Adventure|Science FictionTwentieth Century Fox Film Corporation|Scott Free Productions|Mid Atlantic Films|International Traders|TSG Entertainment9/30/1545727.620159.935996e+075.477497e+08
8211672tt22936407.404165740000001156730962MinionsSandra Bullock|Jon Hamm|Michael Keaton|Allison Janney|Steve Cooganhttp://www.minionsmovie.com/Kyle Balda|Pierre CoffinBefore Gru, they had a history of bad bossesassistant|aftercreditsstinger|duringcreditsstinger|evil mastermind|minionsMinions Stuart, Kevin and Bob are recruited by Scarlet Overkill, a super-villain who, alongside her inventor husband Herb, hatches a plot to take over the world.91Family|Animation|Adventure|ComedyUniversal Pictures|Illumination Entertainment6/17/1528936.520156.807997e+071.064192e+09
9150540tt20966736.326804175000000853708609Inside OutAmy Poehler|Phyllis Smith|Richard Kind|Bill Hader|Lewis Blackhttp://movies.disney.com/inside-outPete DocterMeet the little voices inside your head.dream|cartoon|imaginary friend|animation|kidGrowing up can be a bumpy road, and it's no exception for Riley, who is uprooted from her Midwest life when her father starts a new job in San Francisco. Like all of us, Riley is guided by her emotions - Joy, Fear, Anger, Disgust and Sadness. The emotions live in Headquarters, the control center inside Riley's mind, where they help advise her through everyday life. As Riley and her emotions struggle to adjust to a new life in San Francisco, turmoil ensues in Headquarters. Although Joy, Riley's main and most important emotion, tries to keep things positive, the emotions conflict on how best to navigate a new city, house and school.94Comedy|Animation|FamilyWalt Disney Pictures|Pixar Animation Studios|Walt Disney Studios Motion Pictures6/9/1539358.020151.609999e+087.854116e+08

Last rows

idimdb_idpopularitybudgetrevenueoriginal_titlecasthomepagedirectortaglinekeywordsoverviewruntimegenresproduction_companiesrelease_datevote_countvote_averagerelease_yearbudget_adjrevenue_adj
1085620277tt00611350.14093400The Ugly DachshundDean Jones|Suzanne Pleshette|Charles Ruggles|Kelly Thordsen|Parley BaerNaNNorman TokarA HAPPY HONEYMOON GOES TO THE DOGS!...When a Great Dane disguised as a Dachsie crashes the party!great dane|dachshundThe Garrisons (Dean Jones and Suzanne Pleshette) are the "proud parents" of three adorable dachshund pups -- and one overgrown Great Dane named Brutus, who nevertheless thinks of himself as a dainty dachsie. His identity crisis results in an uproarious series of household crises that reduce the Garrisons' house to shambles -- and viewers to howls of laughter!93Comedy|Drama|FamilyWalt Disney Pictures2/16/66145.719660.0000000.0
108575921tt00607480.13137800Nevada SmithSteve McQueen|Karl Malden|Brian Keith|Arthur Kennedy|Suzanne PleshetteNaNHenry HathawaySome called him savage- and some called him saint... some felt his hate- and one found his love... and three had to die...repayment|revenge|native american|wild west|half breedNevada Smith is the young son of an Indian mother and white father. When his father is killed by three men over gold, Nevada sets out to find them and kill them. The boy is taken in by a gun merchant. The gun merchant shows him how to shoot and to shoot on time and correct.128Action|WesternParamount Pictures|Solar Productions|Embassy Pictures6/10/66105.919660.0000000.0
1085831918tt00609210.31782400The Russians Are Coming, The Russians Are ComingCarl Reiner|Eva Marie Saint|Alan Arkin|Brian Keith|Paul FordNaNNorman JewisonIT'S A PLOT! ...to make the world die laughing!!cold war|russian|new englandWithout hostile intent, a Soviet sub runs aground off New England. Men are sent for a boat, but many villagers go into a tizzy, risking bloodshed.126Comedy|WarThe Mirisch Corporation5/25/66115.519660.0000000.0
1085920620tt00609550.08907200SecondsRock Hudson|Salome Jens|John Randolph|Will Geer|Jeff CoreyNaNJohn FrankenheimerNaNplastic surgery|suspenseA secret organisation offers wealthy people a second chance at life. The customer picks out someone they want to be and the organisation surgically alters the customer to look like the intended person, stages the customer's death, gets rid of the intended person and the customer takes on a new life.100Mystery|Science Fiction|Thriller|DramaGibraltar Productions|Joel Productions|John Frankenheimer Productions Inc.10/5/66226.619660.0000000.0
108605060tt00602140.08703400Carry On Screaming!Kenneth Williams|Jim Dale|Harry H. Corbett|Joan Sims|Charles HawtreyNaNGerald ThomasCarry On Screaming with the Hilarious CARRY ON Gang!!monster|carry on|horror spoofThe sinister Dr Watt has an evil scheme going. He's kidnapping beautiful young women and turning them into mannequins to sell to local stores. Fortunately for Dr Watt, Detective-Sergeant Bung is on the case, and he doesn't have a clue! In this send up of the Hammer Horror movies, there are send-ups of all the horror greats from Frankenstein to Dr Jekyl and Mr Hyde.87ComedyPeter Rogers Productions|Anglo-Amalgamated Film Distributors5/20/66137.019660.0000000.0
1086121tt00603710.08059800The Endless SummerMichael Hynson|Robert August|Lord 'Tally Ho' Blears|Bruce Brown|Chip FitzwaterNaNBruce BrownNaNsurfer|surfboard|surfingThe Endless Summer, by Bruce Brown, is one of the first and most influential surf movies of all times. The film documents American surfers Mike Hynson and Robert August as they travel the world during California’s winter (which back in 1965 was off-season for surfing) in search of the perfect wave and an endless summer.95DocumentaryBruce Brown Films6/15/66117.419660.0000000.0
1086220379tt00604720.06554300Grand PrixJames Garner|Eva Marie Saint|Yves Montand|ToshirÅ Mifune|Brian BedfordNaNJohn FrankenheimerCinerama sweeps YOU into a drama of speed and spectacle!car race|racing|formula 1Grand Prix driver Pete Aron is fired by his team after a crash at Monaco that injures his teammate, Scott Stoddard. While Stoddard struggles to recover, Aron begins to drive for another team, and starts dating Stoddard's wife.176Action|Adventure|DramaCherokee Productions|Joel Productions|Douglas & Lewis Productions12/21/66205.719660.0000000.0
1086339768tt00601610.06514100Beregis AvtomobilyaInnokentiy Smoktunovskiy|Oleg Efremov|Georgi Zhzhyonov|Olga Aroseva|Lyubov DobrzhanskayaNaNEldar RyazanovNaNcar|trolley|stealing carAn insurance agent who moonlights as a carthief steals cars various crooks and never from the common people. He sells the stolen cars and gives the money to charity. His best friend, a cop, is assigned to bring in this modern robin hood.94Mystery|ComedyMosfilm1/1/66116.519660.0000000.0
1086421449tt00611770.06431700What's Up, Tiger Lily?Tatsuya Mihashi|Akiko Wakabayashi|Mie Hama|John Sebastian|Tadao NakamaruNaNWoody AllenWOODY ALLEN STRIKES BACK!spoofIn comic Woody Allen's film debut, he took the Japanese action film "International Secret Police: Key of Keys" and re-dubbed it, changing the plot to make it revolve around a secret egg salad recipe.80Action|ComedyBenedict Pictures Corp.11/2/66225.419660.0000000.0
1086522293tt00606660.035919190000Manos: The Hands of FateHarold P. Warren|Tom Neyman|John Reynolds|Diane Mahree|Stephanie NielsonNaNHarold P. WarrenIt's Shocking! It's Beyond Your Imagination!fire|gun|drive|sacrifice|flashlightA family gets lost on the road and stumbles upon a hidden, underground, devil-worshiping cult led by the fearsome Master and his servant Torgo.74HorrorNorm-Iris11/15/66151.51966127642.2791540.0